![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
TSreorg from Platinum Technologies TSreorg is a graphical tool designed specifically to monitor the structure of your database and to reorganize and defragment the objects in your database to maximize I/O performance. Although TSreorg performs other functions such as job monitoring and scheduling, the real beauty of this product is its ability to reorganize and defragment. Platinum Technologies also offers an excellent suite of system-management products. Precise/SQL Suite from Precise Software Solutions Precise Software Solutions offer two tools to help analyze problems within your applications:
This product is interesting because it focuses on the client application, which is where many performance problems originate. DATA-XPERT from Compuware DATA-XPERT is a useful tool for testing a database that has not yet gone into production. DATA-XPERT is designed to create sample data you can use to test your database. By using a tool like this to generate good quality test data, you can find and fix potential problems before your database and applications are deployed. AdHawk from Eventus Although AdHawk is usually considered a database monitoring tool, it can offer specific recommendations for resolving database problems that may occur. Eventus also offers AdHawk Spacer, a tool that provides for database reorganization and management. DBGENERAL from Bradmark Although Bradmarks DBGENERAL is also primarily seen as a database monitoring tool, the most recent release has increased its functionality. DBGENERAL now provides for reorganization, defragmentation, and capacity management as well as object management. Patrol from BMC Patrol is a powerful tool for monitoring and alerting based on events. Patrol uses knowledge modules to monitor certain events and to communicate with the Patrol console. You can use these knowledge modules to create your own events within the application itself. In this manner, you can monitor every aspect of your system.
SummaryBy taking advantage of SQL development tools for the design of your database, the development of your applications, and for analyzing the outcome of your applications, you can facilitate the optimization of your system. Database design tools can be used to determine where the use of clusters or indexes can help the efficiency of the system. Application development tools can help you rapidly develop, prototype, and deploy graphical applications with a minimal amount of effort. Other tools available on the market can perform specific functions to help remove some of the bottlenecks they discover. Some of these tools perform defragmentation functions; others reorganize database objects for optimal I/O performance. The use of such tools to keep your system running optimally outweighs the purchase price of these products. Performance tuning and optimization does not stop when the system is deployed; it is a ongoing job that can be assisted by the use of the right tool. The use of SQL analysis and tracing tools can assist you in tracking down problem areas and bottlenecks in both the database server and the application. This capability can be useful not only in indicating the cause of a performance problem or bottleneck but also in ruling out areas in question. Performance problems can be associated with the client, the server, or a combination of the two. SQL tracing tools facilitate the determination of the problem and may lead to a solution.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |